SELECT [uf1].[nvarchar14]     ,
        [uf1].[nvarchar4]     ,
        [uf1].[nvarchar6]     ,
        [uf1].[nvarchar5]     ,
        [uf1].[title2],
        [UserInfo].[tp_Title] [title3]
FROM
        (SELECT [uf0].[nvarchar14],
                [uf0].[nvarchar4] ,
                [uf0].[nvarchar6] ,
                [uf0].[nvarchar5] 
				, [uf0].[int3]
                , [UserInfo].[tp_Title] [title2]
        FROM
---
                (SELECT [UserData].[nvarchar14],
                        [UserData].[nvarchar4] ,
                        [UserData].[nvarchar6] ,
                        [UserData].[nvarchar5]
						, [UserData].[int2]
						, [UserData].[int3]
                FROM [UserData]
                        INNER JOIN [Docs]
                        ON ([UserData].[tp_SiteId]       = [Docs].[SiteId]
                            AND [UserData].[tp_DirName]  = [Docs].[DirName]
                            AND [UserData].[tp_LeafName] = [Docs].[LeafName]
                            AND [UserData].[tp_Level]    = [Docs].[Level]
                                )
                WHERE ([UserData].[tp_RowOrdinal] = 0
                    AND [UserData].[tp_ListId]   IN ('fffc05d9-8dad-4107-a75d-384b3e761319', '6422bad6-edc6-41fb-89bd-4c6c832fccc7', '8e2a09c7-d1e5-43ca-ba16-915ebd8965a5', 'adb0f2cf-2881-4aff-81a2-931ce736bfeb', '3ecec760-f1ab-481b-ba7d-8701750c1022', 'c6167bd3-ada0-49fd-b98b-fa5bc5509088', 'e0ddd9e3-8357-41cb-9902-bcf571011e06', '1fffe71c-ff8d-41fc-bfe3-4be32736e4b5', 'd0c64464-b8ed-4d59-9993-987d365cfc2f', '365c3e15-aac5-4e99-9216-8cd5d7809bee', '5deb394a-4c39-45ae-807a-84a803c18f8c', '462cfd9a-031c-446d-b2e4-17e569791f4f', '63fdebaf-ebf7-4256-8fd5-9356408d5209', '94ba52b9-d800-4d6e-a88c-f794f2c638c7', '93d24444-649d-4537-b4c0-e75c4d2096fa', 'c1b871db-bcd3-4e49-8836-f4fa43ae8267', 'dd4f1ab5-7a51-448b-b517-7dab89bf5c2d', '8b4d124a-1366-4cd3-9dcd-8d54e4482aac', '74d86845-7e86-4eb5-b952-1abf1a0c560a', 'fd0763e0-c3da-4adf-b683-fcb91630775f', 'e9ac0306-7ac5-45c6-a707-1f0056b4ebfd', '3f0cefb4-0594-4544-8810-1442418e632c', '8b406c9d-83a9-4c86-b843-1b92139d96ed', 'c3d0b040-d4de-4995-a377-f0033d374382', 'b490f7f7-5c66-4180-bd27-5cf3f66d4f69', '306ff4cc-26eb-44a6-adac-e03e16ac123c', '5df72474-cf56-479e-b59d-9c962a422ec0', 'c27ba84a-679a-40ea-80e0-ea679338b293', '6cde6cbc-c234-4bd6-b502-8fae870b8537', 'aa78733b-f3f7-45d7-8328-101b1618646a', 'a1c1d58e-0e81-4868-9e8a-68b3e4a6e98b', '6d29a16d-b673-4075-abe8-b0378fc47004', 'f8583c7a-8d65-4a5b-ae4a-b51a7c00bc9c', '08c04948-6d3b-43d4-ae3f-5a41e3549115', '1f1f0396-ef3f-489b-a660-94b6f802255e', '51042b89-ae02-4ce5-ae3e-f80677a993d2', 'e153bd44-418b-4ecf-b943-e2462e8e402d', '4bf4b273-0633-4684-9e5c-152d9b51f4a8', '2741661f-2bff-4ff5-b4f8-4a2ae605f562', '0134e685-1c13-4d20-a1b0-884ec4c26848', 'f30a24a1-6d67-424e-9bbd-c776d4dd089c', '408786eb-7ba0-49db-865e-03ae8eb9c532', '6e427e82-feaa-4747-9491-7e77daf13fe6', '66df2b46-8f05-4d8a-a81c-13de3437ad11', '7b5bccee-6569-4555-8c61-879d2c4aba45', '55d9a904-c78b-4ffe-b7f9-f63ac8149639', '88b03833-393e-4ff9-b0cd-28b841205450', '26de6ace-721b-4884-b580-ffc1bbe12d88', 'ab8e8591-b15d-40d2-a40c-911f64b17a02', 'b158157d-1cd0-4297-94f5-41f4db6d17a3', '2a0034ac-905b-452d-b8fe-97d3c624b2d8', 'f3e4cf9a-9311-468d-9c70-9ae851021f81', '93064a9b-4036-479b-af70-65cac897f26c', 'db9f2699-905f-48f2-b804-837c0349e1a3', '33894f29-3108-430c-827c-c06ed3425be3', '248607a4-64f0-47c9-b95c-675d32c74bb7', '4ee837dd-6457-4b0f-819a-6ea972b3d98f', '580bf43f-54dc-4564-bc4d-d409407cdc03', '8793e91e-a55c-4cdc-9892-582548ff61e7', '84f8d563-c90b-489e-98ae-efca78dbb069', '71bddba5-9083-4d07-95ff-3a463b8ea932', '421d5f17-2dae-4088-ad41-d934a7dd543a', '30d5b53a-f1ec-41ba-a690-1df1404b953a', '8e9bac23-fadd-4d6b-9f0b-70429ad514e1', '4dae592f-7e1b-483d-a0f9-e59625709a6c', '2c254e1c-cbbf-402e-8e07-5ba054da9837')
                        )
                )
----
                [uf0]
                LEFT OUTER JOIN [UserInfo]
                ON ([uf0].[int2] = [UserInfo].[tp_ID])
        )
        [uf1]
        LEFT OUTER JOIN [UserInfo]
        ON ([uf1].[int3] = [UserInfo].[tp_ID])